/***********************************************************
* Purpose : Get User_Account by userID and roleID
* Author : DATDT
* Date: 25/3/2012
* Description: Get User_Account by userID and roleID
*/
IF EXISTS ( SELECT * FROM SYSOBJECTS WHERE NAME = 'sp_GetUserAccountByID_RoleID') 
BEGIN
	DROP PROC sp_GetUserAccountByID_RoleID
END
GO
CREATE PROC sp_GetUserAccountByID_RoleID
	@ID int,
	@Roles_ID int
AS
BEGIN
	 if exists (select * from User_Account where ID=@ID and Role_ID= @Roles_ID)
		BEGIN
			SELECT * FROM User_Account where ID=@ID and Role_ID= @Roles_ID
		End

END
--exec sp_GetUserAccountByID_RoleID 0,0